{smcl}
{com}{sf}{ul off}{txt}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}D:\Dropbox\Dropbox\Lueck and Parker\JAERE submission\Final Version 2024\Data and Code for Replication\Log Files\Tables 3, 4, and A8-A12.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res} 5 Nov 2024, 12:07:58

{com}. do "D:\Dropbox\Dropbox\Lueck and Parker\JAERE submission\Final Version 2024\Data and Code for Replication\Agency_Budgets.do"
{txt}
{com}. *Description: See README File
. 
. clear
{txt}
{com}. use "D:\Dropbox\Dropbox\Lueck and Parker\JAERE submission\Final Version 2024\Data and Code for Replication\Expenditures.dta"
{txt}
{com}. joinby year fips using "D:\Dropbox\Dropbox\Lueck and Parker\JAERE submission\Final Version 2024\Data and Code for Replication\Ag1945_2007.dta", unmatched(master)
{txt}
{com}. drop _merge
{txt}
{com}. joinby year fips using "D:\Dropbox\Dropbox\Lueck and Parker\JAERE submission\Final Version 2024\Data and Code for Replication\Pop_PCI_1942_2008.dta", unmatched(master)
{txt}
{com}. drop _merge
{txt}
{com}. joinby fips using "D:\Dropbox\Dropbox\Lueck and Parker\JAERE submission\Final Version 2024\Data and Code for Replication\Precip_Elevation.dta", unmatched(master)
{txt}
{com}. drop _merge
{txt}
{com}. joinby year fips using "D:\Dropbox\Dropbox\Lueck and Parker\JAERE submission\Final Version 2024\Data and Code for Replication\FedLand.dta", unmatched(master)
{txt}
{com}. drop _merge
{txt}
{com}. 
. *Interpolating missing years for farm data
. bysort fips: ipolate facres_ year, g(farmacres_ipo)
{txt}(663552 missing values generated)

{com}. gen farmacres000=farmacres_ipo/1000
{txt}(663,552 missing values generated)

{com}. bysort fips: ipolate farm1000_ year, g(farm1000_ipo)
{txt}(663552 missing values generated)

{com}. gen farms_500more=farm500_ + farm1000_
{txt}(665,904 missing values generated)

{com}. bysort fips: ipolate farms_500more year, g(farms_500more_ipo)
{txt}(663552 missing values generated)

{com}. bysort fips: ipolate avfsize_ year, g(avfarmsz_ipo)
{txt}(663552 missing values generated)

{com}. 
. *Generating inflation adjusted numbers and normalizing variables to make coefficients readable
. gen rstaterev = staterev*cpi_multiplier
{txt}(331,920 missing values generated)

{com}. gen rstaterev000=rstaterev/1000
{txt}(331,920 missing values generated)

{com}. gen beapop000=bea_pop/1000
{txt}(110,592 missing values generated)

{com}. gen fg_exp_tot08 = fg_exp_tot*cpi_multiplier
{txt}(331,920 missing values generated)

{com}. gen bea_pci08 = bea_pci*cpi_multiplier
{txt}(221,184 missing values generated)

{com}. gen totacres000= totacres/1000
{txt}(663,552 missing values generated)

{com}. 
. ******
. 
. *Labeling Variables
. *label var fg_exp_tot08 "spending on fish and game, from govt finance survey, 2008 $s"
. *label var totacres000 "land area of state, in acres"
. *label var fedacres000_ipo "number of federal acres"
. *label var farmacres000 "acres in farms, from Ag. Census"
. *label var farm1000_ipo "# of farms > 1000 acres, from Ag. Census"
. *label var farms_500more_ipo "# of farms > 500 acres, from Ag. Census"
. *label var avfarmsz_ipo "av. farm size in acres, from Ag. Census"
. *label var rstaterev000 "state govt revenue, from govt finance survey, 2008 $s"
. *label var beapop000 "population from BEA"
. *label var bea_pci08 "income per capita, from BEA, 2008 $s"
. *label var precip_inch "average annual precipation, 1971-2000"
. *label var mean_elev_ft "average elevation in feet"
. *label var indep "wildlife agency is autonomous, not part of larger resource/enviro agency"
. 
. *Table A8: Summary Statistics for Analysis of Agency Expenditures
. sum fg_exp_tot08  totacres000 fedacres000_ipo farmacres000 farm1000_ipo farms_500more_ipo avfarmsz_ipo rstaterev000 indep beapop000 bea_pci08 precip_inch mean_elev_ft if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
fg_exp_tot08 {c |}{res}        576    40556.22    43454.55    1388.52   488976.8
{txt}{space 1}totacres000 {c |}{res}        576    39619.11    29730.06     677.12   168217.6
{txt}fedacres00~o {c |}{res}        576    8699.832    14670.01          2      61378
{txt}farmacres000 {c |}{res}        576    21181.83     22717.7     49.601   145600.9
{txt}farm1000_ipo {c |}{res}        576    3383.205    4573.711        1.6    25340.8
{txt}{hline 13}{c +}{hline 57}
farms_500m~o {c |}{res}        576    7380.657    8736.573          7    48602.4
{txt}avfarmsz_ipo {c |}{res}        576     663.526    1084.977         56     6517.8
{txt}rstaterev000 {c |}{res}        576    17024.53    26840.17   282.7222   311425.8
{txt}{space 7}indep {c |}{res}        576    .4583333    .4986939          0          1
{txt}{space 3}beapop000 {c |}{res}        576    4700.852    5073.327        181   36226.12
{txt}{hline 13}{c +}{hline 57}
{space 3}bea_pci08 {c |}{res}        576    25294.34     9103.79    7316.12    58770.4
{txt}{space 1}precip_inch {c |}{res}        576    36.82708    14.13377        9.5       60.1
{txt}mean_elev_ft {c |}{res}        576     1751.25    1836.292         60       6800
{txt}
{com}. 
. *Logging variables for regression analysis
. gen lnfg_exp_tot08 =ln(fg_exp_tot08)
{txt}(553,249 missing values generated)

{com}. gen lnrstaterev=ln(rstaterev)
{txt}(331,920 missing values generated)

{com}. gen lntotacres=ln(totacres)
{txt}(663,552 missing values generated)

{com}. gen lnfedacres000_ipo=ln(fedacres000_ipo)
{txt}(552,960 missing values generated)

{com}. gen lnfarm1000_ipo =ln(farm1000_ipo)
{txt}(663,552 missing values generated)

{com}. gen lnfarms_500more_ipo = ln(farms_500more_ipo)
{txt}(663,552 missing values generated)

{com}. gen lnavfarmsz_ipo = ln(avfarmsz_ipo)
{txt}(663,552 missing values generated)

{com}. gen lnfarmacres_ipo = ln(farmacres000)
{txt}(663,552 missing values generated)

{com}. gen lnbea_pop =ln(bea_pop)
{txt}(110,592 missing values generated)

{com}. gen lnbea_pci08=ln(bea_pci08)
{txt}(221,184 missing values generated)

{com}. gen lnprecip_inch= ln(precip_inch)
{txt}(663,552 missing values generated)

{com}. gen lnmean_elev_ft=ln(mean_elev_ft)
{txt}(663,552 missing values generated)

{com}. 
. *Setting up Expenditures Regressions**
. tab year, gen(year)

       {txt}Year {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
       1942 {c |}{res}    110,592       16.59       16.59
{txt}       1943 {c |}{res}    110,592       16.59       33.18
{txt}       1944 {c |}{res}    110,592       16.59       49.77
{txt}       1945 {c |}{res}         48        0.01       49.78
{txt}       1946 {c |}{res}         48        0.01       49.79
{txt}       1947 {c |}{res}         48        0.01       49.79
{txt}       1948 {c |}{res}         48        0.01       49.80
{txt}       1949 {c |}{res}         48        0.01       49.81
{txt}       1950 {c |}{res}         48        0.01       49.82
{txt}       1951 {c |}{res}         48        0.01       49.82
{txt}       1952 {c |}{res}         48        0.01       49.83
{txt}       1953 {c |}{res}         48        0.01       49.84
{txt}       1954 {c |}{res}         48        0.01       49.85
{txt}       1955 {c |}{res}         48        0.01       49.85
{txt}       1956 {c |}{res}         48        0.01       49.86
{txt}       1957 {c |}{res}         48        0.01       49.87
{txt}       1958 {c |}{res}         48        0.01       49.87
{txt}       1959 {c |}{res}         48        0.01       49.88
{txt}       1960 {c |}{res}         48        0.01       49.89
{txt}       1961 {c |}{res}         48        0.01       49.90
{txt}       1962 {c |}{res}         48        0.01       49.90
{txt}       1963 {c |}{res}         48        0.01       49.91
{txt}       1964 {c |}{res}         48        0.01       49.92
{txt}       1965 {c |}{res}         48        0.01       49.92
{txt}       1966 {c |}{res}         48        0.01       49.93
{txt}       1967 {c |}{res}         48        0.01       49.94
{txt}       1968 {c |}{res}         48        0.01       49.95
{txt}       1969 {c |}{res}         48        0.01       49.95
{txt}       1970 {c |}{res}         48        0.01       49.96
{txt}       1971 {c |}{res}         48        0.01       49.97
{txt}       1972 {c |}{res}         48        0.01       49.97
{txt}       1973 {c |}{res}         48        0.01       49.98
{txt}       1974 {c |}{res}         48        0.01       49.99
{txt}       1975 {c |}{res}         48        0.01       50.00
{txt}       1976 {c |}{res}         48        0.01       50.00
{txt}       1977 {c |}{res}         48        0.01       50.01
{txt}       1978 {c |}{res}         48        0.01       50.02
{txt}       1979 {c |}{res}         48        0.01       50.03
{txt}       1980 {c |}{res}         48        0.01       50.03
{txt}       1981 {c |}{res}         48        0.01       50.04
{txt}       1982 {c |}{res}         48        0.01       50.05
{txt}       1983 {c |}{res}         48        0.01       50.05
{txt}       1984 {c |}{res}         48        0.01       50.06
{txt}       1985 {c |}{res}         48        0.01       50.07
{txt}       1986 {c |}{res}         48        0.01       50.08
{txt}       1987 {c |}{res}         48        0.01       50.08
{txt}       1988 {c |}{res}         48        0.01       50.09
{txt}       1989 {c |}{res}         48        0.01       50.10
{txt}       1990 {c |}{res}         48        0.01       50.10
{txt}       1991 {c |}{res}         48        0.01       50.11
{txt}       1992 {c |}{res}         48        0.01       50.12
{txt}       1993 {c |}{res}         48        0.01       50.13
{txt}       1994 {c |}{res}         48        0.01       50.13
{txt}       1995 {c |}{res}         48        0.01       50.14
{txt}       1996 {c |}{res}         48        0.01       50.15
{txt}       1997 {c |}{res}         48        0.01       50.15
{txt}       1998 {c |}{res}         48        0.01       50.16
{txt}       1999 {c |}{res}         48        0.01       50.17
{txt}       2000 {c |}{res}         48        0.01       50.18
{txt}       2001 {c |}{res}         48        0.01       50.18
{txt}       2002 {c |}{res}         48        0.01       50.19
{txt}       2003 {c |}{res}         48        0.01       50.20
{txt}       2004 {c |}{res}         48        0.01       50.21
{txt}       2005 {c |}{res}         48        0.01       50.21
{txt}       2006 {c |}{res}         48        0.01       50.22
{txt}       2007 {c |}{res}         48        0.01       50.23
{txt}       2008 {c |}{res}    110,592       16.59       66.82
{txt}       2009 {c |}{res}    110,592       16.59       83.41
{txt}       2010 {c |}{res}    110,592       16.59      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    666,576      100.00
{txt}
{com}. tab fips, gen(fips)

 {txt}state fips {c |}
       code {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          1 {c |}{res}         63        2.08        2.08
{txt}          4 {c |}{res}         63        2.08        4.17
{txt}          5 {c |}{res}         63        2.08        6.25
{txt}          6 {c |}{res}         63        2.08        8.33
{txt}          8 {c |}{res}         63        2.08       10.42
{txt}          9 {c |}{res}         63        2.08       12.50
{txt}         10 {c |}{res}         63        2.08       14.58
{txt}         12 {c |}{res}         63        2.08       16.67
{txt}         13 {c |}{res}         63        2.08       18.75
{txt}         16 {c |}{res}         63        2.08       20.83
{txt}         17 {c |}{res}         63        2.08       22.92
{txt}         18 {c |}{res}         63        2.08       25.00
{txt}         19 {c |}{res}         63        2.08       27.08
{txt}         20 {c |}{res}         63        2.08       29.17
{txt}         21 {c |}{res}         63        2.08       31.25
{txt}         22 {c |}{res}         63        2.08       33.33
{txt}         23 {c |}{res}         63        2.08       35.42
{txt}         24 {c |}{res}         63        2.08       37.50
{txt}         25 {c |}{res}         63        2.08       39.58
{txt}         26 {c |}{res}         63        2.08       41.67
{txt}         27 {c |}{res}         63        2.08       43.75
{txt}         28 {c |}{res}         63        2.08       45.83
{txt}         29 {c |}{res}         63        2.08       47.92
{txt}         30 {c |}{res}         63        2.08       50.00
{txt}         31 {c |}{res}         63        2.08       52.08
{txt}         32 {c |}{res}         63        2.08       54.17
{txt}         33 {c |}{res}         63        2.08       56.25
{txt}         34 {c |}{res}         63        2.08       58.33
{txt}         35 {c |}{res}         63        2.08       60.42
{txt}         36 {c |}{res}         63        2.08       62.50
{txt}         37 {c |}{res}         63        2.08       64.58
{txt}         38 {c |}{res}         63        2.08       66.67
{txt}         39 {c |}{res}         63        2.08       68.75
{txt}         40 {c |}{res}         63        2.08       70.83
{txt}         41 {c |}{res}         63        2.08       72.92
{txt}         42 {c |}{res}         63        2.08       75.00
{txt}         44 {c |}{res}         63        2.08       77.08
{txt}         45 {c |}{res}         63        2.08       79.17
{txt}         46 {c |}{res}         63        2.08       81.25
{txt}         47 {c |}{res}         63        2.08       83.33
{txt}         48 {c |}{res}         63        2.08       85.42
{txt}         49 {c |}{res}         63        2.08       87.50
{txt}         50 {c |}{res}         63        2.08       89.58
{txt}         51 {c |}{res}         63        2.08       91.67
{txt}         53 {c |}{res}         63        2.08       93.75
{txt}         54 {c |}{res}         63        2.08       95.83
{txt}         55 {c |}{res}         63        2.08       97.92
{txt}         56 {c |}{res}         63        2.08      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}      3,024      100.00
{txt}
{com}. xtset fips
{txt}{col 8}panel variable:  {res}fips (unbalanced)
{txt}
{com}. 
. *TABLE 3: Panel Estimates of Agency Expenditures on Wildlife, 1952-2007
. eststo clear
{txt}
{com}. eststo: quietly xtreg lnfg_exp_tot08 lnrstaterev lnfarm1000_ipo lnfarmacres_ipo indep lnbea_pop lnbea_pci08 i.year if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007 , fe cluster(fips)
{txt}({res}est1{txt} stored)

{com}. eststo: quietly xtreg lnfg_exp_tot08 lnrstaterev lnfarms_500more_ipo lnfarmacres_ipo indep lnbea_pop lnbea_pci08 if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007 , fe cluster(fips)
{txt}({res}est2{txt} stored)

{com}. eststo: quietly xtreg lnfg_exp_tot08 lnrstaterev lnavfarmsz_ipo lnfarmacres_ipo  indep lnbea_pop lnbea_pci08  i.year  if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007 , fe cluster(fips)
{txt}({res}est3{txt} stored)

{com}. eststo: quietly reg lnfg_exp_tot08 lnrstaterev lnfedacres000_ipo lnfarm1000_ipo lnfarmacres_ipo lntotacres indep lnbea_pop lnbea_pci08 lnprecip_inch lnmean_elev_ft i.year  if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007, cluster(fips)
{txt}({res}est4{txt} stored)

{com}. eststo: quietly reg lnfg_exp_tot08 lnrstaterev lnfedacres000_ipo lnfarms_500more_ipo lnfarmacres_ipo lntotacres indep lnbea_pop lnbea_pci08 lnprecip_inch lnmean_elev_ft i.year if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007, cluster(fips)
{txt}({res}est5{txt} stored)

{com}. eststo: quietly reg lnfg_exp_tot08 lnrstaterev lnavfarmsz_ipo lnfedacres000_ipo lntotacres lnfarmacres_ipo indep lnbea_pop lnbea_pci08 lnprecip_inch lnmean_elev_ft i.year  if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007, cluster(fips)
{txt}({res}est6{txt} stored)

{com}. esttab, se(%6.3f) b(%6.3f) keep(lnrstaterev lnfedacres000_ipo lnfarm1000_ipo lnfarms_500more_ipo  lnavfarmsz_ipo  )  star(* 0.1 ** 0.05 *** 0.01) r2
{res}
{txt}{hline 108}
{txt}                      (1)             (2)             (3)             (4)             (5)             (6)   
{txt}             lnfg_exp_~08    lnfg_exp_~08    lnfg_exp_~08    lnfg_exp_~08    lnfg_exp_~08    lnfg_exp_~08   
{txt}{hline 108}
{txt}lnrstaterev {res}        0.435***        0.347***        0.350**         0.573***        0.569***        0.584***{txt}
            {res} {ralign 12:{txt:(}0.155{txt:)}}    {ralign 12:{txt:(}0.089{txt:)}}    {ralign 12:{txt:(}0.168{txt:)}}    {ralign 12:{txt:(}0.208{txt:)}}    {ralign 12:{txt:(}0.206{txt:)}}    {ralign 12:{txt:(}0.195{txt:)}}   {txt}

{txt}lnfarm1000~o{res}       -0.097**                                        -0.019                                   {txt}
            {res} {ralign 12:{txt:(}0.041{txt:)}}                                    {ralign 12:{txt:(}0.071{txt:)}}                                   {txt}

{txt}lnfarms_50~o{res}                       -0.107*                                          0.017                   {txt}
            {res}                 {ralign 12:{txt:(}0.062{txt:)}}                                    {ralign 12:{txt:(}0.103{txt:)}}                   {txt}

{txt}lnavfarmsz~o{res}                                        0.263                                          -0.218** {txt}
            {res}                                 {ralign 12:{txt:(}0.191{txt:)}}                                    {ralign 12:{txt:(}0.093{txt:)}}   {txt}

{txt}lnfedacres~o{res}                                                        0.157**         0.155**         0.160***{txt}
            {res}                                                 {ralign 12:{txt:(}0.060{txt:)}}    {ralign 12:{txt:(}0.060{txt:)}}    {ralign 12:{txt:(}0.058{txt:)}}   {txt}
{txt}{hline 108}
{txt}N           {res}          576             576             576             576             576             576   {txt}
{txt}R-sq        {res}        0.800           0.781           0.800           0.806           0.806           0.813   {txt}
{txt}{hline 108}
{txt}Standard errors in parentheses
{txt}* p<0.1, ** p<0.05, *** p<0.01

{com}. 
. *TABLE A9: Panel Estimates of Agency Expenditures on Wildlife, 1952-2007 with All Coefficients
. eststo clear
{txt}
{com}. eststo: quietly xtreg lnfg_exp_tot08 lnrstaterev lnfarm1000_ipo lnfarmacres_ipo indep lnbea_pop lnbea_pci08 i.year if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007 , fe cluster(fips)
{txt}({res}est1{txt} stored)

{com}. eststo: quietly xtreg lnfg_exp_tot08 lnrstaterev lnfarms_500more_ipo lnfarmacres_ipo indep lnbea_pop lnbea_pci08 if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007 , fe cluster(fips)
{txt}({res}est2{txt} stored)

{com}. eststo: quietly xtreg lnfg_exp_tot08 lnrstaterev lnavfarmsz_ipo lnfarmacres_ipo  indep lnbea_pop lnbea_pci08  i.year  if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007 , fe cluster(fips)
{txt}({res}est3{txt} stored)

{com}. eststo: quietly reg lnfg_exp_tot08 lnrstaterev lnfedacres000_ipo lnfarm1000_ipo lnfarmacres_ipo lntotacres indep lnbea_pop lnbea_pci08 lnprecip_inch lnmean_elev_ft i.year  if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007, cluster(fips)
{txt}({res}est4{txt} stored)

{com}. eststo: quietly reg lnfg_exp_tot08 lnrstaterev lnfedacres000_ipo lnfarms_500more_ipo lnfarmacres_ipo lntotacres indep lnbea_pop lnbea_pci08 lnprecip_inch lnmean_elev_ft i.year if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007, cluster(fips)
{txt}({res}est5{txt} stored)

{com}. eststo: quietly reg lnfg_exp_tot08 lnrstaterev lnavfarmsz_ipo lnfedacres000_ipo lntotacres lnfarmacres_ipo indep lnbea_pop lnbea_pci08 lnprecip_inch lnmean_elev_ft i.year  if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007, cluster(fips)
{txt}({res}est6{txt} stored)

{com}. esttab, se(%6.3f) b(%6.3f) keep(lnrstaterev lnfedacres000_ipo lnfarms_500more_ipo lnavfarmsz_ipo lnfarmacres_ipo lntotacres indep lnbea_pop lnbea_pci08 lnprecip_inch lnmean_elev_ft _cons)  star(* 0.1 ** 0.05 *** 0.01) r2
{res}
{txt}{hline 108}
{txt}                      (1)             (2)             (3)             (4)             (5)             (6)   
{txt}             lnfg_exp_~08    lnfg_exp_~08    lnfg_exp_~08    lnfg_exp_~08    lnfg_exp_~08    lnfg_exp_~08   
{txt}{hline 108}
{txt}lnrstaterev {res}        0.435***        0.347***        0.350**         0.573***        0.569***        0.584***{txt}
            {res} {ralign 12:{txt:(}0.155{txt:)}}    {ralign 12:{txt:(}0.089{txt:)}}    {ralign 12:{txt:(}0.168{txt:)}}    {ralign 12:{txt:(}0.208{txt:)}}    {ralign 12:{txt:(}0.206{txt:)}}    {ralign 12:{txt:(}0.195{txt:)}}   {txt}

{txt}lnfarmacre~o{res}        0.364***        0.286**         0.196          -0.054          -0.097          -0.033   {txt}
            {res} {ralign 12:{txt:(}0.133{txt:)}}    {ralign 12:{txt:(}0.138{txt:)}}    {ralign 12:{txt:(}0.159{txt:)}}    {ralign 12:{txt:(}0.156{txt:)}}    {ralign 12:{txt:(}0.175{txt:)}}    {ralign 12:{txt:(}0.145{txt:)}}   {txt}

{txt}indep       {res}       -0.039          -0.035          -0.049           0.065           0.070           0.111   {txt}
            {res} {ralign 12:{txt:(}0.068{txt:)}}    {ralign 12:{txt:(}0.065{txt:)}}    {ralign 12:{txt:(}0.069{txt:)}}    {ralign 12:{txt:(}0.103{txt:)}}    {ralign 12:{txt:(}0.108{txt:)}}    {ralign 12:{txt:(}0.105{txt:)}}   {txt}

{txt}lnbea_pop   {res}       -0.027           0.095           0.248          -0.223          -0.207          -0.289   {txt}
            {res} {ralign 12:{txt:(}0.135{txt:)}}    {ralign 12:{txt:(}0.131{txt:)}}    {ralign 12:{txt:(}0.169{txt:)}}    {ralign 12:{txt:(}0.191{txt:)}}    {ralign 12:{txt:(}0.189{txt:)}}    {ralign 12:{txt:(}0.182{txt:)}}   {txt}

{txt}lnbea_pci08 {res}        0.767**         0.648***        0.743**         0.863**         0.843**         0.968***{txt}
            {res} {ralign 12:{txt:(}0.311{txt:)}}    {ralign 12:{txt:(}0.177{txt:)}}    {ralign 12:{txt:(}0.299{txt:)}}    {ralign 12:{txt:(}0.331{txt:)}}    {ralign 12:{txt:(}0.329{txt:)}}    {ralign 12:{txt:(}0.292{txt:)}}   {txt}

{txt}lnfarms_50~o{res}                       -0.107*                                          0.017                   {txt}
            {res}                 {ralign 12:{txt:(}0.062{txt:)}}                                    {ralign 12:{txt:(}0.103{txt:)}}                   {txt}

{txt}lnavfarmsz~o{res}                                        0.263                                          -0.218** {txt}
            {res}                                 {ralign 12:{txt:(}0.191{txt:)}}                                    {ralign 12:{txt:(}0.093{txt:)}}   {txt}

{txt}lnfedacres~o{res}                                                        0.157**         0.155**         0.160***{txt}
            {res}                                                 {ralign 12:{txt:(}0.060{txt:)}}    {ralign 12:{txt:(}0.060{txt:)}}    {ralign 12:{txt:(}0.058{txt:)}}   {txt}

{txt}lntotacres  {res}                                                        0.348           0.343           0.376   {txt}
            {res}                                                 {ralign 12:{txt:(}0.292{txt:)}}    {ralign 12:{txt:(}0.289{txt:)}}    {ralign 12:{txt:(}0.277{txt:)}}   {txt}

{txt}lnprecip_i~h{res}                                                        0.569***        0.540**         0.236   {txt}
            {res}                                                 {ralign 12:{txt:(}0.199{txt:)}}    {ralign 12:{txt:(}0.213{txt:)}}    {ralign 12:{txt:(}0.261{txt:)}}   {txt}

{txt}lnmean_ele~t{res}                                                       -0.010          -0.007          -0.055   {txt}
            {res}                                                 {ralign 12:{txt:(}0.074{txt:)}}    {ralign 12:{txt:(}0.067{txt:)}}    {ralign 12:{txt:(}0.074{txt:)}}   {txt}

{txt}_cons       {res}       -6.739*         -5.012**        -9.736**       -12.390***      -12.072***      -10.808***{txt}
            {res} {ralign 12:{txt:(}3.923{txt:)}}    {ralign 12:{txt:(}2.131{txt:)}}    {ralign 12:{txt:(}4.570{txt:)}}    {ralign 12:{txt:(}4.007{txt:)}}    {ralign 12:{txt:(}4.041{txt:)}}    {ralign 12:{txt:(}3.599{txt:)}}   {txt}
{txt}{hline 108}
{txt}N           {res}          576             576             576             576             576             576   {txt}
{txt}R-sq        {res}        0.800           0.781           0.800           0.806           0.806           0.813   {txt}
{txt}{hline 108}
{txt}Standard errors in parentheses
{txt}* p<0.1, ** p<0.05, *** p<0.01

{com}. 
. *Generating region fixed effects and region x year fixed effects for Table A10
. 
. gen region1=0
{txt}
{com}. replace region1=1 if state=="Connecticut"|state=="Maine"|state=="New Hampshire"|state=="Vermont"
{txt}(55,548 real changes made)

{com}. replace region1=2 if state=="New Jersey"|state=="New York"|state=="Pennsylvania"
{txt}(41,661 real changes made)

{com}. replace region1=3 if state=="Illinois"|state=="Indiana"|state=="Michigan"|state=="Ohio"|state=="Wisconsin"
{txt}(69,435 real changes made)

{com}. replace region1=4 if state=="Iowa"|state=="Kansas"|state=="Minnesota"|state=="Missouri"|state=="Nebraska"|state=="North Dakota"|state=="South Dakota"
{txt}(97,209 real changes made)

{com}. replace region1=5 if state=="Delaware"|state=="Virginia"|state=="Florida"|state=="Georgia"|state=="North Carolina"|state=="South Carolina"|state=="Maryland"|state=="West Virginia"
{txt}(111,096 real changes made)

{com}. replace region1=6 if state=="Alabama"|state=="Mississippi"|state=="Kentucky"|state=="Tennessee"
{txt}(55,548 real changes made)

{com}. replace region1=7 if state=="Arkansas"|state=="Louisiana"|state=="Texas"|state=="Oklahoma"
{txt}(55,548 real changes made)

{com}. replace region1=8 if state=="Arizona"|state=="Colorado"|state=="Idaho"|state=="Montana"|state=="Nevada"|state=="New Mexico"|state=="Utah"|state=="Wyoming"
{txt}(111,096 real changes made)

{com}. replace region1=9 if state=="California"|state=="Oregon"|state=="Washington"
{txt}(41,661 real changes made)

{com}. 
. tab region1, gen(reg1)

    {txt}region1 {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}     27,774        4.17        4.17
{txt}          1 {c |}{res}     55,548        8.33       12.50
{txt}          2 {c |}{res}     41,661        6.25       18.75
{txt}          3 {c |}{res}     69,435       10.42       29.17
{txt}          4 {c |}{res}     97,209       14.58       43.75
{txt}          5 {c |}{res}    111,096       16.67       60.42
{txt}          6 {c |}{res}     55,548        8.33       68.75
{txt}          7 {c |}{res}     55,548        8.33       77.08
{txt}          8 {c |}{res}    111,096       16.67       93.75
{txt}          9 {c |}{res}     41,661        6.25      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    666,576      100.00
{txt}
{com}. 
. gen region2=0
{txt}
{com}. replace region2=1 if region1==1|region1==2
{txt}(97,209 real changes made)

{com}. replace region2=2 if region1==3|region1==4
{txt}(166,644 real changes made)

{com}. replace region2=3 if region1==5
{txt}(111,096 real changes made)

{com}. replace region2=4 if region1==6|region1==7
{txt}(111,096 real changes made)

{com}. replace region2=5 if region1==8|region1==9
{txt}(152,757 real changes made)

{com}. 
. tab region2, gen(reg2)

    {txt}region2 {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}     27,774        4.17        4.17
{txt}          1 {c |}{res}     97,209       14.58       18.75
{txt}          2 {c |}{res}    166,644       25.00       43.75
{txt}          3 {c |}{res}    111,096       16.67       60.42
{txt}          4 {c |}{res}    111,096       16.67       77.08
{txt}          5 {c |}{res}    152,757       22.92      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}    666,576      100.00
{txt}
{com}. 
. *generating region x year FE*
. foreach var of varlist year1-year69 {c -(}
{txt}  2{com}. gen reg21`var' = reg21*`var'
{txt}  3{com}. {c )-}
{txt}
{com}. foreach var of varlist year1-year69 {c -(}
{txt}  2{com}. gen reg22`var' = reg22*`var'
{txt}  3{com}. {c )-}
{txt}
{com}. foreach var of varlist year1-year69  {c -(}
{txt}  2{com}. gen reg23`var' = reg23*`var'
{txt}  3{com}. {c )-}
{txt}
{com}. foreach var of varlist year1-year69 {c -(}
{txt}  2{com}. gen reg24`var' = reg24*`var'
{txt}  3{com}. {c )-}
{txt}
{com}. foreach var of varlist year1-year69 {c -(}
{txt}  2{com}. gen reg25`var' = reg25*`var'
{txt}  3{com}. {c )-}
{txt}
{com}. foreach var of varlist year1-year69{c -(}
{txt}  2{com}. gen reg26`var' = reg26*`var'
{txt}  3{com}. {c )-}
{txt}
{com}. 
. *TABLE A10: Panel Estimates of Agency Expenditures on Wildlife, 1952-2007 with All Coefficients & Region Fixed Effects
. eststo clear 
{txt}
{com}. eststo: quietly xtreg lnfg_exp_tot08 lnrstaterev lnfarm1000_ipo lnfarmacres_ipo indep lnbea_pop lnbea_pci08 i.year reg21year1- reg26year69 if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007 , fe cluster(fips)
{txt}({res}est1{txt} stored)

{com}. eststo: quietly xtreg lnfg_exp_tot08 lnrstaterev lnfarms_500more_ipo lnfarmacres_ipo indep lnbea_pop lnbea_pci08 i.year reg21year1- reg26year69 if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007 , fe cluster(fips)
{txt}({res}est2{txt} stored)

{com}. eststo: quietly xtreg lnfg_exp_tot08 lnrstaterev lnavfarmsz_ipo lnfarmacres_ipo  indep lnbea_pop lnbea_pci08 i.year reg21year1- reg26year69 if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007 , fe cluster(fips)
{txt}({res}est3{txt} stored)

{com}. eststo: quietly reg lnfg_exp_tot08 lnrstaterev lnfedacres000_ipo lnfarm1000_ipo lnfarmacres_ipo lntotacres indep lnbea_pop lnbea_pci08 lnprecip_inch lnmean_elev_ft i.year reg21-reg26 if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007, cluster(fips)
{txt}({res}est4{txt} stored)

{com}. eststo: quietly reg lnfg_exp_tot08 lnrstaterev lnfedacres000_ipo lnfarms_500more_ipo lnfarmacres_ipo lntotacres indep lnbea_pop lnbea_pci08 lnprecip_inch lnmean_elev_ft i.year reg21-reg26 if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007, cluster(fips)
{txt}({res}est5{txt} stored)

{com}. eststo: quietly reg lnfg_exp_tot08 lnrstaterev lnavfarmsz_ipo lnfedacres000_ipo lntotacres lnfarmacres_ipo indep lnbea_pop lnbea_pci08 lnprecip_inch lnmean_elev_ft i.year reg21-reg26 if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007, cluster(fips)
{txt}({res}est6{txt} stored)

{com}. esttab, se(%6.3f) b(%6.3f) keep(lnrstaterev lnfedacres000_ipo lnfarm1000_ipo lnfarms_500more_ipo lnavfarmsz_ipo  lnfarmacres_ipo lntotacres indep lnbea_pop lnbea_pci08 lnprecip_inch lnmean_elev_ft)  star(* 0.1 ** 0.05 *** 0.01) r2
{res}
{txt}{hline 108}
{txt}                      (1)             (2)             (3)             (4)             (5)             (6)   
{txt}             lnfg_exp_~08    lnfg_exp_~08    lnfg_exp_~08    lnfg_exp_~08    lnfg_exp_~08    lnfg_exp_~08   
{txt}{hline 108}
{txt}lnrstaterev {res}        0.424**         0.467**         0.326*          0.476**         0.466**         0.401** {txt}
            {res} {ralign 12:{txt:(}0.193{txt:)}}    {ralign 12:{txt:(}0.201{txt:)}}    {ralign 12:{txt:(}0.190{txt:)}}    {ralign 12:{txt:(}0.218{txt:)}}    {ralign 12:{txt:(}0.220{txt:)}}    {ralign 12:{txt:(}0.184{txt:)}}   {txt}

{txt}lnfarm1000~o{res}       -0.131**                                        -0.025                                   {txt}
            {res} {ralign 12:{txt:(}0.050{txt:)}}                                    {ralign 12:{txt:(}0.069{txt:)}}                                   {txt}

{txt}lnfarmacre~o{res}        0.265           0.297           0.214           0.028          -0.042           0.182   {txt}
            {res} {ralign 12:{txt:(}0.239{txt:)}}    {ralign 12:{txt:(}0.239{txt:)}}    {ralign 12:{txt:(}0.248{txt:)}}    {ralign 12:{txt:(}0.163{txt:)}}    {ralign 12:{txt:(}0.179{txt:)}}    {ralign 12:{txt:(}0.132{txt:)}}   {txt}

{txt}indep       {res}       -0.026          -0.024          -0.031           0.037           0.045           0.057   {txt}
            {res} {ralign 12:{txt:(}0.072{txt:)}}    {ralign 12:{txt:(}0.073{txt:)}}    {ralign 12:{txt:(}0.075{txt:)}}    {ralign 12:{txt:(}0.093{txt:)}}    {ralign 12:{txt:(}0.094{txt:)}}    {ralign 12:{txt:(}0.085{txt:)}}   {txt}

{txt}lnbea_pop   {res}       -0.086          -0.107           0.089          -0.153          -0.125          -0.225   {txt}
            {res} {ralign 12:{txt:(}0.208{txt:)}}    {ralign 12:{txt:(}0.209{txt:)}}    {ralign 12:{txt:(}0.207{txt:)}}    {ralign 12:{txt:(}0.203{txt:)}}    {ralign 12:{txt:(}0.205{txt:)}}    {ralign 12:{txt:(}0.172{txt:)}}   {txt}

{txt}lnbea_pci08 {res}        0.651*          0.609*          0.852**         0.635*          0.601*          0.913***{txt}
            {res} {ralign 12:{txt:(}0.335{txt:)}}    {ralign 12:{txt:(}0.322{txt:)}}    {ralign 12:{txt:(}0.333{txt:)}}    {ralign 12:{txt:(}0.369{txt:)}}    {ralign 12:{txt:(}0.355{txt:)}}    {ralign 12:{txt:(}0.277{txt:)}}   {txt}

{txt}lnfarms_50~o{res}                       -0.235***                                        0.037                   {txt}
            {res}                 {ralign 12:{txt:(}0.083{txt:)}}                                    {ralign 12:{txt:(}0.109{txt:)}}                   {txt}

{txt}lnavfarmsz~o{res}                                        0.161                                          -0.407***{txt}
            {res}                                 {ralign 12:{txt:(}0.221{txt:)}}                                    {ralign 12:{txt:(}0.092{txt:)}}   {txt}

{txt}lnfedacres~o{res}                                                        0.126*          0.124*          0.117** {txt}
            {res}                                                 {ralign 12:{txt:(}0.065{txt:)}}    {ralign 12:{txt:(}0.065{txt:)}}    {ralign 12:{txt:(}0.057{txt:)}}   {txt}

{txt}lntotacres  {res}                                                        0.358           0.349           0.396*  {txt}
            {res}                                                 {ralign 12:{txt:(}0.250{txt:)}}    {ralign 12:{txt:(}0.245{txt:)}}    {ralign 12:{txt:(}0.214{txt:)}}   {txt}

{txt}lnprecip_i~h{res}                                                        0.687***        0.638***        0.124   {txt}
            {res}                                                 {ralign 12:{txt:(}0.227{txt:)}}    {ralign 12:{txt:(}0.226{txt:)}}    {ralign 12:{txt:(}0.246{txt:)}}   {txt}

{txt}lnmean_ele~t{res}                                                       -0.064          -0.061          -0.191***{txt}
            {res}                                                 {ralign 12:{txt:(}0.065{txt:)}}    {ralign 12:{txt:(}0.059{txt:)}}    {ralign 12:{txt:(}0.066{txt:)}}   {txt}
{txt}{hline 108}
{txt}N           {res}          576             576             576             576             576             576   {txt}
{txt}R-sq        {res}        0.835           0.837           0.833           0.817           0.817           0.835   {txt}
{txt}{hline 108}
{txt}Standard errors in parentheses
{txt}* p<0.1, ** p<0.05, *** p<0.01

{com}. 
. *Prepping variables for Table A11 Placebo Estimates
. 
. gen hh_exp_tot08 =  hh_exp_tot*cpi_multiplier
{txt}(331,920 missing values generated)

{com}. gen pr_exp_tot08 = pr_exp_tot*cpi_multiplier
{txt}(331,920 missing values generated)

{com}. gen ag_exp_tot08 = ag_exp_tot*cpi_multiplier
{txt}(331,920 missing values generated)

{com}. gen for_exp_tot08 =for_exp_tot*cpi_multiplier
{txt}(331,920 missing values generated)

{com}. 
. *Labeling Variables
. label var hh_exp_tot08 "spending on health & hospitals, from govt finance survey, 2008 $s"
{txt}
{com}. label var pr_exp_tot08 "spending on parks, from govt finance survey, 2008 $s"
{txt}
{com}. label var pr_exp_tot08 "spending on agriculture, from govt finance survey, 2008 $s"
{txt}
{com}. label var pr_exp_tot08 "spending on forests, from govt finance survey, 2008 $s"
{txt}
{com}. 
. gen lnhh_exp_tot=ln(hh_exp_tot08)
{txt}(331,920 missing values generated)

{com}. gen lnpr_exp_tot=ln(pr_exp_tot08)
{txt}(554,497 missing values generated)

{com}. gen lnfor_exp_tot=ln(for_exp_tot08)
{txt}(560,262 missing values generated)

{com}. gen lnag_exp_tot=ln(ag_exp_tot08)
{txt}(663,984 missing values generated)

{com}. 
. *TABLE A11, PLACEBO ESTIMATES FOR HEALTH, PARKS, FORESTRY, AND AGRICULTURE
. eststo clear
{txt}
{com}. eststo: quietly xtreg lnhh_exp_tot lnrstaterev lnfarm1000_ipo lnfarmacres_ipo indep lnbea_pop lnbea_pci08  i.year if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007 , fe cluster(fips)
{txt}({res}est1{txt} stored)

{com}. eststo: quietly xtreg lnpr_exp_tot lnrstaterev lnfarm1000_ipo lnfarmacres_ipo indep lnbea_pop lnbea_pci08 i.year if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007 , fe cluster(fips)
{txt}({res}est2{txt} stored)

{com}. eststo: quietly xtreg lnag_exp_tot lnrstaterev lnfarm1000_ipo lnfarmacres_ipo indep lnbea_pop lnbea_pci08  i.year if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007 , fe cluster(fips)
{txt}({res}est3{txt} stored)

{com}. eststo: quietly xtreg lnfor_exp_tot lnrstaterev lnfarm1000_ipo lnfarmacres_ipo indep lnbea_pop lnbea_pci08  i.year if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007 , fe cluster(fips)
{txt}({res}est4{txt} stored)

{com}. eststo: quietly xtreg lnhh_exp_tot lnrstaterev lnavfarmsz_ipo lnfedacres000_ipo lntotacres lnfarmacres_ipo indep lnbea_pop lnbea_pci08 lnprecip_inch lnmean_elev_ft  i.year if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007 , fe cluster(fips)
{txt}({res}est5{txt} stored)

{com}. eststo: quietly xtreg lnpr_exp_tot lnrstaterev lnavfarmsz_ipo lnfedacres000_ipo lntotacres lnfarmacres_ipo indep lnbea_pop lnbea_pci08 lnprecip_inch lnmean_elev_ft i.year if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007 , fe cluster(fips)
{txt}({res}est6{txt} stored)

{com}. eststo: quietly xtreg lnag_exp_tot lnrstaterev lnavfarmsz_ipo lnfedacres000_ipo lntotacres lnfarmacres_ipo indep lnbea_pop lnbea_pci08 lnprecip_inch lnmean_elev_ft  i.year if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007 , fe cluster(fips)
{txt}({res}est7{txt} stored)

{com}. eststo: quietly xtreg lnfor_exp_tot lnrstaterev lnavfarmsz_ipo lnfedacres000_ipo lntotacres lnfarmacres_ipo indep lnbea_pop lnbea_pci08 lnprecip_inch lnmean_elev_ft  i.year if year==1952|year==1957|year==1962|year==1967|year==1972|year==1977|year==1982|year==1987|year==1992|year==1997|year==2002|year==2007 , fe cluster(fips)
{txt}({res}est8{txt} stored)

{com}. esttab, se(%6.3f) b(%6.3f) keep(lnrstaterev lnfarm1000_ipo lnavfarmsz_ipo lnfedacres000_ipo)  star(* 0.1 ** 0.05 *** 0.01) r2
{res}
{txt}{hline 140}
{txt}                      (1)             (2)             (3)             (4)             (5)             (6)             (7)             (8)   
{txt}             lnhh_exp_tot    lnpr_exp_tot    lnag_exp_tot    lnfor_exp_~t    lnhh_exp_tot    lnpr_exp_tot    lnag_exp_tot    lnfor_exp_~t   
{txt}{hline 140}
{txt}lnrstaterev {res}        0.312**        -0.152           0.079           0.097           0.277*         -0.203           0.143          -0.183   {txt}
            {res} {ralign 12:{txt:(}0.150{txt:)}}    {ralign 12:{txt:(}0.370{txt:)}}    {ralign 12:{txt:(}0.175{txt:)}}    {ralign 12:{txt:(}0.480{txt:)}}    {ralign 12:{txt:(}0.158{txt:)}}    {ralign 12:{txt:(}0.361{txt:)}}    {ralign 12:{txt:(}0.163{txt:)}}    {ralign 12:{txt:(}0.438{txt:)}}   {txt}

{txt}lnfarm1000~o{res}       -0.056          -0.052           0.091*         -0.385**                                                                 {txt}
            {res} {ralign 12:{txt:(}0.059{txt:)}}    {ralign 12:{txt:(}0.191{txt:)}}    {ralign 12:{txt:(}0.052{txt:)}}    {ralign 12:{txt:(}0.149{txt:)}}                                                                   {txt}

{txt}lnavfarmsz~o{res}                                                                        0.183           0.437           0.545***        0.318   {txt}
            {res}                                                                 {ralign 12:{txt:(}0.164{txt:)}}    {ralign 12:{txt:(}0.418{txt:)}}    {ralign 12:{txt:(}0.137{txt:)}}    {ralign 12:{txt:(}0.425{txt:)}}   {txt}

{txt}lnfedacres~o{res}                                                                       -0.039           0.059           0.167**        -0.303   {txt}
            {res}                                                                 {ralign 12:{txt:(}0.055{txt:)}}    {ralign 12:{txt:(}0.258{txt:)}}    {ralign 12:{txt:(}0.071{txt:)}}    {ralign 12:{txt:(}0.193{txt:)}}   {txt}
{txt}{hline 140}
{txt}N           {res}          576             335             528             552             576             335             528             552   {txt}
{txt}R-sq        {res}        0.933           0.378           0.753           0.505           0.933           0.385           0.776           0.491   {txt}
{txt}{hline 140}
{txt}Standard errors in parentheses
{txt}* p<0.1, ** p<0.05, *** p<0.01

{com}. 
. *Inputting expenditures on nongame in each state for 1986, 1992, and 1998
. 
. gen ngexp=.
{txt}(666,576 missing values generated)

{com}. replace ngexp=  171228.0702     if      state== "Alabama"       & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  377543.8596     if      state== "Alaska"        & year==        1986
{txt}(0 real changes made)

{com}. replace ngexp=  701754.386      if      state== "Arizona"       & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  175438.5965     if      state== "Arkansas"      & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  21192982.46     if      state== "California"    & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  1403508.772     if      state== "Colorado"      & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  182456.1404     if      state== "Connecticut"   & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  58947.36842     if      state== "Delaware"      & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  2105263.158     if      state== "Florida"       & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  196491.2281     if      state== "Georgia"       & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  429473.6842     if      state== "Hawaii"        & year==        1986
{txt}(0 real changes made)

{com}. replace ngexp=  129122.807      if      state== "Idaho" & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  1964912.281     if      state== "Illinois"      & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  428070.1754     if      state== "Indiana"       & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  186666.6667     if      state== "Iowa"  & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  686315.7895     if      state== "Kansas"        & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  154385.9649     if      state== "Kentucky"      & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  105263.1579     if      state== "Louisiana"     & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  175438.5965     if      state== "Maine" & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  175438.5965     if      state== "Maryland"      & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  416842.1053     if      state== "Massachusetts" & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  842105.2632     if      state== "Michigan"      & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  960000  if      state== "Minnesota"     & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  0       if      state== "Mississippi"   & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  3508771.93      if      state== "Missouri"      & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  284912.2807     if      state== "Montana"       & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  350877.193      if      state== "Nebraska"      & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  294736.8421     if      state== "Nevada"        & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  0       if      state== "New Hampshire" & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  631578.9474     if      state== "New Jersey"    & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  645614.0351     if      state== "New Mexico"    & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  1868070.175     if      state== "New York"      & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  280701.7544     if      state== "North Carolina"        & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  70175.4386      if      state== "North Dakota"  & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  491228.0702     if      state== "Ohio"  & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  186666.6667     if      state== "Oklahoma"      & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  725614.0351     if      state== "Oregon"        & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  969824.5614     if      state== "Pennsylvania"  & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  61754.38596     if      state== "Rhode Island"  & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  421052.6316     if      state== "South Carolina"        & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  70175.4386      if      state== "South Dakota"  & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  315789.4737     if      state== "Tennessee"     & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  252631.5789     if      state== "Texas" & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  997894.7368     if      state== "Utah"  & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  70175.4386      if      state== "Vermont"       & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  842105.2632     if      state== "Virginia"      & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  1122807.018     if      state== "Washington"    & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  161403.5088     if      state== "West Virginia" & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  280701.7544     if      state== "Wisconsin"     & year==        1986
{txt}(1 real change made)

{com}. replace ngexp=  937543.8596     if      state== "Wyoming"       & year==        1986
{txt}(1 real change made)

{com}. 
. replace ngexp=  582277.0157     if      state== "Alabama"       & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  318342.3048     if      state== "Alaska"        & year==        1992
{txt}(0 real changes made)

{com}. replace ngexp=  5632048.388     if      state== "Arizona"       & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  231507.7849     if      state== "Arkansas"      & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  1528043.063     if      state== "California"    & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  4168702.9       if      state== "Colorado"      & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  39358.68496     if      state== "Connecticut"   & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  107251.2589     if      state== "Delaware"      & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  2473809.11      if      state== "Florida"       & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  892829.7737     if      state== "Georgia"       & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  1203912.716     if      state== "Hawaii"        & year==        1992
{txt}(0 real changes made)

{com}. replace ngexp=  949751.693      if      state== "Idaho" & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  2752906.176     if      state== "Illinois"      & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  560192.163      if      state== "Indiana"       & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  226517.3352     if      state== "Iowa"  & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  226916.7101     if      state== "Kansas"        & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  365881.8082     if      state== "Kentucky"      & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  210684.7254     if      state== "Louisiana"     & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  404880.4769     if      state== "Maine" & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  653901.719      if      state== "Maryland"      & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  548484.1118     if      state== "Massachusetts" & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  1551836.546     if      state== "Michigan"      & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  1946217.515     if      state== "Minnesota"     & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  288259.5358     if      state== "Mississippi"   & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  6965144.412     if      state== "Missouri"      & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  150053.8288     if      state== "Montana"       & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  526555.5363     if      state== "Nebraska"      & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  327603.1718     if      state== "Nevada"        & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  104184.7543     if      state== "New Hampshire" & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  776176.4195     if      state== "New Jersey"    & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  1524490.363     if      state== "New Mexico"    & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  14574868.32     if      state== "New York"      & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  534412.2243     if      state== "North Carolina"        & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  60195.63582     if      state== "North Dakota"  & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  817046.941      if      state== "Ohio"  & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  287252.4165     if      state== "Oklahoma"      & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  1960356.543     if      state== "Oregon"        & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  951667.5349     if      state== "Pennsylvania"  & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  352707.0672     if      state== "Rhode Island"  & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  751287.8393     if      state== "South Carolina"        & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  130578.2254     if      state== "South Dakota"  & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  447415.6393     if      state== "Tennessee"     & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  2137871.158     if      state== "Texas" & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  1833545.176     if      state== "Utah"  & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  308832.5519     if      state== "Vermont"       & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  1165982.52      if      state== "Virginia"      & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  5967471.204     if      state== "Washington"    & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  206870.4057     if      state== "West Virginia" & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  2012458.181     if      state== "Wisconsin"     & year==        1992
{txt}(1 real change made)

{com}. replace ngexp=  5242425.19      if      state== "Wyoming"       & year==        1992
{txt}(1 real change made)

{com}. 
. replace ngexp=  479040.5506     if      state== "Alabama"       & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  295422.506      if      state== "Alaska"        & year==        1998
{txt}(0 real changes made)

{com}. replace ngexp=  7161947.508     if      state== "Arizona"       & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  458884.4432     if      state== "Arkansas"      & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  .       if      state== "California"    & year==        1998
{txt}(0 real changes made)

{com}. replace ngexp=  5912798.532     if      state== "Colorado"      & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  190298.7395     if      state== "Connecticut"   & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  421954.5568     if      state== "Delaware"      & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  9364157.476     if      state== "Florida"       & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  9646247.616     if      state== "Georgia"       & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  1523680.446     if      state== "Hawaii"        & year==        1998
{txt}(0 real changes made)

{com}. replace ngexp=  623915.7476     if      state== "Idaho" & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  6990836.719     if      state== "Illinois"      & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  483041.7116     if      state== "Indiana"       & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  234258.645      if      state== "Iowa"  & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  318745.3354     if      state== "Kansas"        & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  550914.2549     if      state== "Kentucky"      & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  557674.7657     if      state== "Louisiana"     & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  1135044.365     if      state== "Maine" & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  1220675.429     if      state== "Maryland"      & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  781893.1918     if      state== "Massachusetts" & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  4732720.375     if      state== "Michigan"      & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  1307115.018     if      state== "Minnesota"     & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  1749730.492     if      state== "Mississippi"   & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  11581978.19     if      state== "Missouri"      & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  2875408.409     if      state== "Montana"       & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  549190.4387     if      state== "Nebraska"      & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  565967.3273     if      state== "Nevada"        & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  195419.3963     if      state== "New Hampshire" & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  883676.0925     if      state== "New Jersey"    & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  796241.3965     if      state== "New Mexico"    & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  1841521.892     if      state== "New York"      & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  801022.0582     if      state== "North Carolina"        & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  70486.77336     if      state== "North Dakota"  & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  2837432.623     if      state== "Ohio"  & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  678616.5934     if      state== "Oklahoma"      & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  1568218.758     if      state== "Oregon"        & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  558711.3359     if      state== "Pennsylvania"  & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  53900.61365     if      state== "Rhode Island"  & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  836027.0338     if      state== "South Carolina"        & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  489779.4179     if      state== "South Dakota"  & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  1401304.005     if      state== "Tennessee"     & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  1938386.268     if      state== "Texas" & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  1579701.882     if      state== "Utah"  & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  392534.6214     if      state== "Vermont"       & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  1144373.497     if      state== "Virginia"      & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  9425074.633     if      state== "Washington"    & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  783854.3826     if      state== "West Virginia" & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  2186312.091     if      state== "Wisconsin"     & year==        1998
{txt}(1 real change made)

{com}. replace ngexp=  3255348.702     if      state== "Wyoming"       & year==        1998
{txt}(1 real change made)

{com}. 
. *Putting expenditures in 2008 dollars and replacing null spending with zeroes for a few states
. gen perngexp08= ngexp*cpi_multiplier/(fg_exp_tot08*1000)
{txt}(666,433 missing values generated)

{com}. replace perngexp08=0 if year==1986 & perngexp08==.
{txt}(0 real changes made)

{com}. replace perngexp08=0 if year==1992 & perngexp08==.
{txt}(0 real changes made)

{com}. gen lnnongame_exp=ln(ngexp)
{txt}(666,435 missing values generated)

{com}. 
. *Table 4: Pooled Estimates of Nongame expenditures
. eststo clear 
{txt}
{com}. eststo: quietly reg lnnongame_exp lnrstaterev lntotacres lnfarmacres_ipo  lnfedacres000_ipo lnavfarmsz_ipo   indep lnbea_pop lnbea_pci08 lnprecip_inch lnmean_elev_ft i.year, cluster(fips)
{txt}({res}est1{txt} stored)

{com}. eststo: quietly reg lnnongame_exp lnrstaterev lntotacres lnfarmacres_ipo  lnfedacres000_ipo lnavfarmsz_ipo  indep lnbea_pop lnbea_pci08 lnprecip_inch lnmean_elev_ft reg21-reg26 i.year, cluster(fips)
{txt}({res}est2{txt} stored)

{com}. eststo: quietly reg perngexp08 lnrstaterev lntotacres lnfarmacres_ipo  lnfedacres000_ipo lnavfarmsz_ipo  indep lnbea_pop lnbea_pci08 lnprecip_inch lnmean_elev_ft i.year, cluster(fips)
{txt}({res}est3{txt} stored)

{com}. eststo: quietly reg perngexp08 lnrstaterev lntotacres lnfarmacres_ipo  lnfedacres000_ipo lnavfarmsz_ipo  indep lnbea_pop lnbea_pci08 lnprecip_inch lnmean_elev_ft reg21-reg26 i.year, cluster(fips)
{txt}({res}est4{txt} stored)

{com}. esttab, se(%6.3f) b(%6.3f) keep(lnrstaterev lnfedacres000_ipo  lnavfarmsz_ipo _cons )  star(* 0.1 ** 0.05 *** 0.01) r2
{res}
{txt}{hline 76}
{txt}                      (1)             (2)             (3)             (4)   
{txt}             lnnongame_~p    lnnongame_~p      perngexp08      perngexp08   
{txt}{hline 76}
{txt}lnrstaterev {res}        0.820           0.473           0.010           0.005   {txt}
            {res} {ralign 12:{txt:(}0.567{txt:)}}    {ralign 12:{txt:(}0.609{txt:)}}    {ralign 12:{txt:(}0.040{txt:)}}    {ralign 12:{txt:(}0.040{txt:)}}   {txt}

{txt}lnfedacres~o{res}        0.350***        0.310**         0.006           0.012   {txt}
            {res} {ralign 12:{txt:(}0.123{txt:)}}    {ralign 12:{txt:(}0.146{txt:)}}    {ralign 12:{txt:(}0.007{txt:)}}    {ralign 12:{txt:(}0.009{txt:)}}   {txt}

{txt}lnavfarmsz~o{res}        0.537**         0.445           0.049***        0.064***{txt}
            {res} {ralign 12:{txt:(}0.218{txt:)}}    {ralign 12:{txt:(}0.268{txt:)}}    {ralign 12:{txt:(}0.017{txt:)}}    {ralign 12:{txt:(}0.019{txt:)}}   {txt}

{txt}_cons       {res}      -19.018          -9.801          -0.679          -0.109   {txt}
            {res} {ralign 12:{txt:(}14.021{txt:)}}    {ralign 12:{txt:(}14.056{txt:)}}    {ralign 12:{txt:(}0.722{txt:)}}    {ralign 12:{txt:(}0.778{txt:)}}   {txt}
{txt}{hline 76}
{txt}N           {res}          141             141             143             143   {txt}
{txt}R-sq        {res}        0.615           0.658           0.240           0.300   {txt}
{txt}{hline 76}
{txt}Standard errors in parentheses
{txt}* p<0.1, ** p<0.05, *** p<0.01

{com}. 
. *Table A12: Pooled Estimates of Nongame expenditures with all Coefficients
. eststo clear 
{txt}
{com}. eststo: quietly reg lnnongame_exp lnrstaterev lnfedacres000_ipo lnavfarmsz_ipo  lntotacres lnfarmacres_ipo indep lnbea_pop lnbea_pci08 lnprecip_inch lnmean_elev_ft i.year, cluster(fips)
{txt}({res}est1{txt} stored)

{com}. eststo: quietly reg lnnongame_exp lnrstaterev lnfedacres000_ipo lnavfarmsz_ipo  lntotacres lnfarmacres_ipo indep lnbea_pop lnbea_pci08 lnprecip_inch lnmean_elev_ft reg21-reg26 i.year, cluster(fips)
{txt}({res}est2{txt} stored)

{com}. eststo: quietly reg perngexp08 lnrstaterev lnfedacres000_ipo lnavfarmsz_ipo  lntotacres lnfarmacres_ipo  indep lnbea_pop lnbea_pci08 lnprecip_inch lnmean_elev_ft i.year, cluster(fips)
{txt}({res}est3{txt} stored)

{com}. eststo: quietly reg perngexp08 lnrstaterev lnfedacres000_ipo lnavfarmsz_ipo  lntotacres lnfarmacres_ipo   indep lnbea_pop lnbea_pci08 lnprecip_inch lnmean_elev_ft reg21-reg26 i.year, cluster(fips)
{txt}({res}est4{txt} stored)

{com}. esttab, se(%6.3f) b(%6.3f) keep(lnrstaterev lnfedacres000_ipo lnavfarmsz_ipo  lntotacres lnfarmacres_ipo    indep lnbea_pop lnbea_pci08 lnprecip_inch lnmean_elev_ft _cons )  star(* 0.1 ** 0.05 *** 0.01) r2
{res}
{txt}{hline 76}
{txt}                      (1)             (2)             (3)             (4)   
{txt}             lnnongame_~p    lnnongame_~p      perngexp08      perngexp08   
{txt}{hline 76}
{txt}lnrstaterev {res}        0.820           0.473           0.010           0.005   {txt}
            {res} {ralign 12:{txt:(}0.567{txt:)}}    {ralign 12:{txt:(}0.609{txt:)}}    {ralign 12:{txt:(}0.040{txt:)}}    {ralign 12:{txt:(}0.040{txt:)}}   {txt}

{txt}lnfedacres~o{res}        0.350***        0.310**         0.006           0.012   {txt}
            {res} {ralign 12:{txt:(}0.123{txt:)}}    {ralign 12:{txt:(}0.146{txt:)}}    {ralign 12:{txt:(}0.007{txt:)}}    {ralign 12:{txt:(}0.009{txt:)}}   {txt}

{txt}lnavfarmsz~o{res}        0.537**         0.445           0.049***        0.064***{txt}
            {res} {ralign 12:{txt:(}0.218{txt:)}}    {ralign 12:{txt:(}0.268{txt:)}}    {ralign 12:{txt:(}0.017{txt:)}}    {ralign 12:{txt:(}0.019{txt:)}}   {txt}

{txt}lntotacres  {res}       -0.305          -0.257          -0.029          -0.040*  {txt}
            {res} {ralign 12:{txt:(}0.605{txt:)}}    {ralign 12:{txt:(}0.520{txt:)}}    {ralign 12:{txt:(}0.026{txt:)}}    {ralign 12:{txt:(}0.024{txt:)}}   {txt}

{txt}lnfarmacre~o{res}        0.007           0.184          -0.001          -0.002   {txt}
            {res} {ralign 12:{txt:(}0.290{txt:)}}    {ralign 12:{txt:(}0.285{txt:)}}    {ralign 12:{txt:(}0.012{txt:)}}    {ralign 12:{txt:(}0.014{txt:)}}   {txt}

{txt}indep       {res}       -0.236          -0.178          -0.015          -0.013   {txt}
            {res} {ralign 12:{txt:(}0.198{txt:)}}    {ralign 12:{txt:(}0.204{txt:)}}    {ralign 12:{txt:(}0.011{txt:)}}    {ralign 12:{txt:(}0.011{txt:)}}   {txt}

{txt}lnbea_pop   {res}       -0.034           0.253           0.023           0.036   {txt}
            {res} {ralign 12:{txt:(}0.599{txt:)}}    {ralign 12:{txt:(}0.672{txt:)}}    {ralign 12:{txt:(}0.041{txt:)}}    {ralign 12:{txt:(}0.042{txt:)}}   {txt}

{txt}lnbea_pci08 {res}        1.395           0.520           0.014          -0.053   {txt}
            {res} {ralign 12:{txt:(}1.147{txt:)}}    {ralign 12:{txt:(}1.082{txt:)}}    {ralign 12:{txt:(}0.063{txt:)}}    {ralign 12:{txt:(}0.066{txt:)}}   {txt}

{txt}lnprecip_i~h{res}        0.927           1.304*          0.044           0.074*  {txt}
            {res} {ralign 12:{txt:(}0.641{txt:)}}    {ralign 12:{txt:(}0.677{txt:)}}    {ralign 12:{txt:(}0.030{txt:)}}    {ralign 12:{txt:(}0.043{txt:)}}   {txt}

{txt}lnmean_ele~t{res}        0.147          -0.034           0.010           0.008   {txt}
            {res} {ralign 12:{txt:(}0.195{txt:)}}    {ralign 12:{txt:(}0.184{txt:)}}    {ralign 12:{txt:(}0.008{txt:)}}    {ralign 12:{txt:(}0.009{txt:)}}   {txt}

{txt}_cons       {res}      -19.018          -9.801          -0.679          -0.109   {txt}
            {res} {ralign 12:{txt:(}14.021{txt:)}}    {ralign 12:{txt:(}14.056{txt:)}}    {ralign 12:{txt:(}0.722{txt:)}}    {ralign 12:{txt:(}0.778{txt:)}}   {txt}
{txt}{hline 76}
{txt}N           {res}          141             141             143             143   {txt}
{txt}R-sq        {res}        0.615           0.658           0.240           0.300   {txt}
{txt}{hline 76}
{txt}Standard errors in parentheses
{txt}* p<0.1, ** p<0.05, *** p<0.01

{com}. 
{txt}end of do-file

{com}. log close
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}D:\Dropbox\Dropbox\Lueck and Parker\JAERE submission\Final Version 2024\Data and Code for Replication\Log Files\Tables 3, 4, and A8-A12.smcl
  {txt}log type:  {res}smcl
 {txt}closed on:  {res} 5 Nov 2024, 12:10:08
{txt}{.-}
{smcl}
{txt}{sf}{ul off}